﻿CREATE TABLE [dbo].[DimEB_270]
(
[RecordID] [bigint] NULL,
[ActivityID] [nvarchar] (128) NULL,
[InfoSource_NM101_SourceEntityIdentifierCode] [nvarchar] (50) NULL,
[InfoSource_NM103_SourceLastOrOrganizationName] [nvarchar] (50) NULL,
[InfoSource_NM109_SourcePrimaryIdentifier] [nvarchar] (100) NULL,
[InfoReceiver_NM101_ReceiverEntityIdentifierCode] [nvarchar] (50) NULL,
[InfoReceiver_NM102_ReceiverEntityTypeQualifier] [nvarchar] (50) NULL,
[InfoReceiver_NM103_ReceiverLastOrOrganizationName] [nvarchar] (50) NULL,
[InfoReceiver_NM109_ReceiverIDNumber] [nvarchar] (100) NULL,
[InfoReceiver_REF01_ReceiverRefIDQualifier] [nvarchar] (50) NULL,
[InfoReceiver_REF02_ReceiverAdditionalIdentifier] [nvarchar] (100) NULL,
[InfoReceiver_REF03_LicenseNumberStateCode] [nvarchar] (100) NULL,
[Subscriber_TRN02_TraceNumber] [nvarchar] (50) NULL,
[Subscriber_TRN03_TraceAssigningEntityID] [nvarchar] (50) NULL,
[Subscriber_TRN04_TraceAssigningEntityAdditionalID] [nvarchar] (50) NULL,
[Subscriber_NM103_SubscriberDependentLastName] [nvarchar] (50) NULL,
[Subscriber_NM104_SubscriberDependentFirstName] [nvarchar] (50) NULL,
[Subscriber_NM109_SubscriberPrimaryIdentifier] [nvarchar] (100) NULL,
[IsDependent] [nvarchar] (50) NULL,
[SendRequest] [datetime] NULL,
[Subscriber_PRV01_ProviderCode] [nvarchar] (50) NULL,
[Subscriber_PRV03_ProviderIdentifier] [nvarchar] (50) NULL,
[BHT03_SubmitterTransactionIdentifier] [nvarchar] (50) NULL,
[CommunicationMethod] [nvarchar] (50) NULL,
[RoutedTo] [nvarchar] (50) NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL,
[Receive_UTC] [datetime] NULL,
[EB270_ID_Key] [int] NOT NULL IDENTITY(1, 1),
[Receive_LocalTime] AS (dateadd(hour, -datediff(hour,getdate(),getutcdate()),[Receive_UTC])),
[InsertDate] [datetime] NULL
) ON [PRIMARY]


